Problem Note 36982: Measure filters appear to be wrong when applied to SAS® Web Report Studio tables and graphs that use OLAP data
 |  |  |  |
When filtering a table or graph based on relational data, measure filters are applied after category filters. This behavior is explained in the Filter & Rank dialog box, which contains the following text.
The measure filter will be applied after any category filters.
However, when filtering a table or graph based on OLAP data, measure filters are applied to the values of the underlying cube instead of to the values that are visible in the table or graph. For this reason, you might see values in the table or graph that you would not see if the measure filter had been applied based on visible category filters.
For example, in the following display, Central has a value of 320 and Southwest has a value of 394. These columns appear because the COST_N filter has been applied to the cube data and not the data visible in the table.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Web Report Studio | Microsoft Windows Server 2008 | 4.2 | 4.31 | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Standard Edition | 4.2 | 4.31 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 4.2 | 4.31 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 4.2 | 4.31 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft® Windows® for x64 | 4.2 | 4.31 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| z/OS | 4.2 | 4.31 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows XP Professional | 4.2 | 4.31 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Windows Vista | 4.2 | 4.31 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| 64-bit Enabled AIX | 4.2 | 4.31 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| 64-bit Enabled Solaris | 4.2 | 4.31 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| HP-UX IPF | 4.2 | 4.31 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Linux for x64 | 4.2 | 4.31 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Solaris for x64 | 4.2 | 4.31 | 9.2 TS2M0 | 9.3 TS1M0 | ||